package com.mskj.zxmy.mapper;


import com.mskj.zxmy.entity.User;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UserMapper {

    @Select("select * from password_auth where username = #{username}")
    User findByUserName(String username);

    @Select("select nick from corp_member where memberId = #{memberId}")
    String findNickByMemberId(String memberId);

    @Select("select corp_member.memberId from corp_member where userId = #{userId}")
    String findByMemberId(String userId);
}
